Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Below is my sample data. I have created a simple Bar chart with
Dimensions: DRILL group of Category, Sub-Category, Brand, Products
Expression: Sum(Price INR)
My Query:-
1. On the very first selection / click on any Bar of the Chart, nothing should happen; the bars must remain steady (like as if its Locked).
Vehicles:
2. On 2nd time selection / click on any Bar of the Chart, the Dimension must Drill down from Category to Sub-category and so on.
I have tried Triggers by using Lock All but then it doesn't allow me selection further is I use Select In Field.
LOAD * INLINE [
ID, Category, Sub-Category, Brand, Products, Price INR
1, 4wheeler, SUV, Maruti, Ertiga, "600,000"
2, 4wheeler, Hathchback, Maruti, Alto k-10, "385,000"
3, 4wheeler, Hathchback, Maruti, Swift, "725,000"
4, 4wheeler, Sedan, Maruti, Swift Dzire, "850,000"
5, 4wheeler, Hathchback, Tata, Nano AMT, "290,000"
6, 4wheeler, Hathchback, Tata, Tiago, "530,000"
7, 4wheeler, SUV, Tata, Safari, "930,000"
8, 4wheeler, Sedan, Tata, Zest, "813,000"
9, 4wheeler, Sedan, Toyota, Corolla, "1,492,000"
10, 4wheeler, Hathchback, Toyota, Etios Liva, "580,000"
11, 4wheeler, Hathchback, Toyota, Etios Cross, "7,70,000"
12, 4wheeler, SUV, Toyota, Innova, "1,627,000"
13, 4wheeler, SUV, Toyota, Fortuner, "2,759,000"
14, 4wheeler, SUV, Skoda, Yeti, "2,310,000"
15, 4wheeler, Sedan, Skoda, Rapid, "737,000"
16, 4wheeler, Sedan, Skoda, Laura, "1,570,000"
17, 4wheeler, Hathchback, Skoda, Fabia, "750,000"
18, 4wheeler, SUV, Mahindra, XUV 500, "1,722,000"
19, 2wheeler, Bike, Hero, Impulse, "71,400"
20, 2wheeler, Bike, Hero, Hunk, "72,825"
21, 2wheeler, Moped, Hero, Duet, "48,600"
22, 2wheeler, Moped, Hero, Pleasure, "46,400"
23, 2wheeler, Moped, Yamaha, Fascino, "53,300"
24, 2wheeler, Bike, Yamaha, YZF R3, "326,000"
25, 2wheeler, Moped, Mahindra, Gusto, "49,350"
26, 2wheeler, Moped, Mahindra, Rodeo, "47,450"
27, 2wheeler, Moped, Honda, Activa i, "68,540"
28, 2wheeler, Moped, Honda, Dio, "59,650"
29, 2wheeler, Bike, Hero, Pulsar, "86,985"
30, 2wheeler, Bike, Honda, Unicorn, "75,452"
];
What is the use case for the first step?
In general, I would try to avoid using triggers for something that is counter intuitive and not following the way QV usually works.
1. On the very first selection / click on any Bar of the Chart, nothing should happen; the bars must remain steady (like as if its Locked).
What are you trying to achieve by doing this?
Andy
It was asked in an interview; The Interviewer said it was his client requirement. This was one of his example of why Qlikview is being different from other BI tools like Tableau and Spotfire.