Qlik Sense June 2018 Technical Preview is now available


The Qlik Sense June 2018 Preview includes new features like:

Insight advisor automatically generating insights into your data
Publishing apps from the hub
The ability to filter data from files
An updated Expression Editor
Vertical resizing of sheets
Workflow improvements for editing visualizations
Line layers in multi-layer map charts
Accessibility improvements
5 new Qlik Connectors




LKY Quotes


Lee Kuan Yew, the autocratic founder of modern Singapore who died Monday, never shrank from expressing his views bluntly. He was known as much for his tough talk as a pithy turn of phrase in campaign speeches, press interviews and parliamentary debates. Here are some of his oft-quoted comments:

Everybody knows that in my bag I have a hatchet, and a very sharp one. You take me on, I take my hatchet, we meet in the cul-de-sac. That’s the way I had to survive in the past. That’s the way the communists tackled me. (Speaking about his harsh treatment of opposition politician J B Jeyaretnam in “Lee Kuan Yew: The Man and His Ideas,” 1998)

I am often accused of interfering in the private lives of citizens. Yes, if I did not, had I not done that, we wouldn’t be here today. And I say without the slightest remorse, that we wouldn’t be here, we would not have made economic progress, if we had not intervened on very personal matters – who your neighbor is, how you live, the noise you make, how you spit, or what language you use. We decide what is right. Never mind what the people think. (The Straits Times, April 20, 1987)

Repression, sir, is a habit that grows. I am told it is like making love — it is always easier the second time! The first time there may be pangs of conscience, a sense of guilt. But once embarked on this course with constant repetition you get more and more brazen in the attack. All you have to do is to dissolve organizations and societies and banish and detain the key political workers in these societies. Then miraculously everything is tranquil on the surface. Then an intimidated press and the government-controlled radio together can regularly sing your praises, and slowly and steadily the people are made to forget the evil things that have already been done, or if these things are referred to again they’re conveniently distorted and distorted with impunity, because there will be no opposition to contradict. (Addressing colonial-era prime minister David Marshall as an opposition Peoples’ Action Party member in the Singapore Legislative Assembly, Oct. 4, 1956)

Whoever governs Singapore must have that iron in him. Or give it up. This is not a game of cards. This is your life and mine. I’ve spent a whole lifetime building this and as long as I’m in charge, nobody is going to knock it down. (Speech at a rally in Raffles Place, Singapore in 1980)

You call me a dictator. You are entitled to call me whatever you like, but that doesn’t make me one . . . do I need to be a dictator when I can win, hands down? (Quoted in an interview with the New York Times at the World Economic Forum in Davos, Switzerland, 1999)

I’m very determined. If I decide what something is worth doing, then I’ll put my heart and soul to it. The whole ground can be against me, but if I know it is right, I’ll do it. That’s the business of a leader. (Lee Kuan Yew, “The Man and His Ideas,” 1998)

The Americans should know the character of the men they are dealing with in Singapore and not get themselves further dragged into calumny. They are not dealing with Ngo Dinh Diem or Syngman Rhee. You do not buy and sell this government. (Quoted in a New York Times article reporting the CIA’s attempt to bribe him with $3.3 million in 1965)

I have never been over concerned or obsessed with opinion polls or popularity polls. I think a leader who is, is a weak leader. Between being loved and being feared, I have always believed Machiavelli was right. If nobody is afraid of me, I’m meaningless. (“The Singapore Story: Memoirs of Lee Kuan Yew,” 1998)

Even from my sick bed, even if you are going to lower me into the grave, and I feel something is wrong, I will get up. (Speaking at the 1988 National Day Rally)

“Anybody who decides to take me on needs to put on knuckle-dusters. If you think you can hurt me more than I can hurt you, try. There is no way you can govern a Chinese society.”

“Life is not just eating, drinking, television and cinema. The human mind must be creative, must be self-generating; it cannot depend on just gadgets to amuse itself.”

“If you can select a population and they’re educated and they’re properly brought up, then you don’t have to use too much of the stick because they would already have been trained. It’s like with dogs. You train it in a proper way from small. It will know that it’s got to leave, go outside to pee and to defecate. No, we are not that kind of society. We had to train adult dogs who even today deliberately urinate in the lifts.”

“At the end of the day, what have I got? A successful Singapore. What have I given up? My life.”

48 Laws of Power

1 http://sudharmasabha.blogspot.com/2009/01/law-1.html
2 http://sudharmasabha.blogspot.com/2009/01/law-2.html
3 http://sudharmasabha.blogspot.com/2009/01/law-3.html
4 http://sudharmasabha.blogspot.com/2009/01/law-4.html
5 http://sudharmasabha.blogspot.com/2009/01/law-5.html
6 http://sudharmasabha.blogspot.com/2009/01/law-6.html
7 http://sudharmasabha.blogspot.com/2009/01/law-7.html
8 http://sudharmasabha.blogspot.com/2009/01/law-8.html
9 http://sudharmasabha.blogspot.com/2009/01/law-9.html
10 http://sudharmasabha.blogspot.com/2009/01/law-10.html
11 http://sudharmasabha.blogspot.com/2009/01/law-11.html
12 http://sudharmasabha.blogspot.com/2009/01/law-12.html
13 http://sudharmasabha.blogspot.com/2009/01/law-13.html
14 http://sudharmasabha.blogspot.com/2009/01/law-14.html
15 http://sudharmasabha.blogspot.com/2009/01/law-15.html
16 http://sudharmasabha.blogspot.com/2009/01/law-16.html
17 http://sudharmasabha.blogspot.com/2009/01/law-17.html
18 http://sudharmasabha.blogspot.com/2009/01/law-18.html
19 http://sudharmasabha.blogspot.com/2009/01/law-19.html
20 http://sudharmasabha.blogspot.com/2009/01/law-20.html
21 http://sudharmasabha.blogspot.com/2009/01/law-21.html
22 http://sudharmasabha.blogspot.com/2009/01/law-22.html
23 http://sudharmasabha.blogspot.com/2009/01/law-23.html
24 http://sudharmasabha.blogspot.com/2009/01/law-24.html
25 http://sudharmasabha.blogspot.com/2009/01/law-25.html
26 http://sudharmasabha.blogspot.com/2009/01/law-26.html
27 http://sudharmasabha.blogspot.com/2009/01/law-27.html
28 http://sudharmasabha.blogspot.com/2009/01/law-28.html
29 http://sudharmasabha.blogspot.com/2009/01/law-29.html
30 http://sudharmasabha.blogspot.com/2009/01/law-30.html
31 http://sudharmasabha.blogspot.com/2009/01/law-31.html
32 http://sudharmasabha.blogspot.com/2009/01/law-32.html
33 http://sudharmasabha.blogspot.com/2009/01/law-33.html
34 http://sudharmasabha.blogspot.com/2009/01/law-34.html
35 http://sudharmasabha.blogspot.com/2009/01/law-35.html
36 http://sudharmasabha.blogspot.com/2009/01/law-36.html
37 http://sudharmasabha.blogspot.com/2009/01/law-37.html
38 http://sudharmasabha.blogspot.com/2009/01/law-38.html
39 http://sudharmasabha.blogspot.com/2009/01/law-39.html
40 http://sudharmasabha.blogspot.com/2009/01/law-40.html
41 http://sudharmasabha.blogspot.com/2009/01/law-41.html
42 http://sudharmasabha.blogspot.com/2009/01/law-42.html
43 http://sudharmasabha.blogspot.com/2009/01/law-43.html
44 http://sudharmasabha.blogspot.com/2009/01/law-44.html
45 http://sudharmasabha.blogspot.com/2009/01/law-45.html
46 http://sudharmasabha.blogspot.com/2009/01/law-46.html
47 http://sudharmasabha.blogspot.com/2009/01/law-47.html
48 http://sudharmasabha.blogspot.com/2009/01/law-48.html

Bar for selected dimension value


When I click on any of the Dimension on the bar chart, It must show the bar for only selected value of the Dimension. How to achieve this?

LOAD *,Ceil(Rand()*100) as Measure INLINE [





Max month sales of each Year?

This is the data
Product SalesDate SalesAmount
Apple Jan-30-2017 $100
Apple Feb-28-2017 $50
Apple March-30-2017 $200
Apple Jan-30-2018 $200
Apple Feb-28-2018 $100
Apple March-30-2018 $300
Apple April-30-2018 $400
Required Output
Product SalesDate SalesAmount
Apple March-30-2017 $200
Apple April-30-2018 $400

date(date#(SalesDate,’MMM-DD-YYYY’)) as SalesDate,
Month(date#(SalesDate,’MMM-DD-YYYY’)) as Month,
Year(date#(SalesDate,’MMM-DD-YYYY’)) as Year,
date(date#(SalesDate,’MMM-DD-YYYY’),’MMM-YYYY’) as MonthYear,
Inline [

How to fill the empty rows with previous value?

We have the data like this.

Sno SNumber Date
2 1 01/11/2017
3 2
4 3
5 4
6 5
7 1 02/11/2017
8 2
9 3
10 1 03/11/2017
11 2
12 3
13 4
14 5
15 1 04/11/2017
16 2
17 3
18 4
19 5
20 6


How to show the data like below?

Sno SNumber Date_Field
2 1 01/11/2017
3 2 01/11/2017
4 3 01/11/2017
5 4 01/11/2017
6 5 01/11/2017
7 1 02/11/2017
8 2 02/11/2017
9 3 02/11/2017
10 1 03/11/2017
11 2 03/11/2017
12 3 03/11/2017
13 4 03/11/2017
14 5 03/11/2017
15 1 04/11/2017
16 2 04/11/2017
17 3 04/11/2017
18 4 04/11/2017
19 5 04/11/2017
20 6 04/11/2017


LOAD *,if(len(trim(Date))=0, peek(Date,RecNo()-SNumber), Date) as Date_Field;
LOAD *,RecNo() as Sno INLINE [

How to load BIG NUMBERS in Qlik?

How to load BIG NUMBERS like more than 14,15 and even 17 digits?

How to load BIG NUMBERS like more than 14,15 and even 17 digits?

If you want all 16 digits, and treat it like text, you can load it as


but then you cannot use it as a number.

You can also load it using

Dual(Field, Evaluate(Field))

Then you will get the original string (all 16 digits) as the textual value, and the evaluated string as numeric value. This works fine as long as you don’t have two field values with identical 15 digits, but different 16th digit.