topic Re: Expression Drill Down in QlikView

Expression Drill Down

Wed, 01 Apr 2015 12:49:46 GMT

Hey,

I have been using Qlikview for a while, nd have some knowledge of Cyclic and Drill Down Group, But do we have something like this for expressions?

I have one line chart with sum({<Category={'PC'}>}TargetQuant) as expression and Month as Dimension.

now I want something with which I can show sum({<Category={'Notebook'}>}TargetQuant),sum({<Category={'Desktop'}>}TargetQuant) at second level.

Please help in this.

Regards,

Navdeep

Re: Expression Drill Down

stigchel — Wed, 01 Apr 2015 12:52:59 GMT

You can group expressions by clicking on group or simply by dragging one expression on top of the other. A cyclic expression button will appear in the chart

Re: Expression Drill Down

Wed, 01 Apr 2015 13:01:56 GMT

Can I have 2 expressions in first level and 4 expressions in second level, as I have Target and Achieved in 1 level and further I want target and achieved for 2 subcategories of 1 level in 2 level?

Re: Expression Drill Down

stigchel — Wed, 01 Apr 2015 13:03:46 GMT

Yes you can

Re: Expression Drill Down

Wed, 01 Apr 2015 13:04:36 GMT

Could you please guide me how to do that.

Re: Expression Drill Down

stigchel — Wed, 01 Apr 2015 13:07:26 GMT

Simply click and drag the expression on top of the one(s) you want to group it with

Re: Expression Drill Down

stigchel — Wed, 01 Apr 2015 13:11:48 GMT

Maybe I misunderstood you, it is not possible to have a level below an already grouped level, but you can create two groups

Re: Expression Drill Down

Wed, 01 Apr 2015 13:14:08 GMT

I tried your suggestion, But my requirement is first Target and Achievment lines and then on drill down further 4 trend lines, I don't want to change them one by one.

Re: Expression Drill Down

Wed, 01 Apr 2015 13:16:41 GMT

Ok, I am planning to give button and then will overlay chart having 4 expressions. Is there any better way?

Re: Expression Drill Down

stigchel — Wed, 01 Apr 2015 13:19:46 GMT

Maybe you can do something with the suggestion of John here:

How to get the used expression?