topic Re: Need help with conditional expression in QlikView

Need help with conditional expression

Tue, 02 Sep 2014 22:54:05 GMT

I am trying to create multiple pie charts on one sheet. Each pie chart will contain a subset of the overall data I am trying to display with conditional expressions, however I am running into issues.

One of the pie charts I am trying to create should show the number of SKU's based on the following SKU_MODEL however, when I enter this into the conditional portion of the expression it shows all SKU Models, not just the one. What am I doing wrong?

=Count({$<SKU_MODEL={"CIS"}>}DISTINCT(MATNR))

Re: Need help with conditional expression

MarcoWedel — Tue, 02 Sep 2014 23:16:30 GMT

=Count({$<SKU_MODEL={'CIS'}>}DISTINCT(MATNR))

Do single quotes work?

Re: Need help with conditional expression

Tue, 02 Sep 2014 23:27:05 GMT

No, that does not work either.

This is how I am using the expression.

Re: Need help with conditional expression

phaneendra_kunc — Tue, 02 Sep 2014 23:27:38 GMT

Your Expression works. But not sure where you are writing..Seems you are writing in Conditional show box.

Conditional boxes will take just TRUE/FALSE statements.

Write you expression in "Definition box" ... Refer attached.

Re: Need help with conditional expression

Tue, 02 Sep 2014 23:36:41 GMT

Thanks for the help. However I am still having problems in that I am using a multi box to do some additional filtering of the data. However it seems that the multi box is not affecting the chart with the conditional expression. Why is this happening?

Re: Need help with conditional expression

phaneendra_kunc — Tue, 02 Sep 2014 23:38:23 GMT

Can you post a sample?

Re: Need help with conditional expression

Tue, 02 Sep 2014 23:44:29 GMT

Here are screenshots.

No filter

With Filter

No change when I selected filters.

Re: Need help with conditional expression

phaneendra_kunc — Tue, 02 Sep 2014 23:48:41 GMT

Are you using alternate states? if then in order to work based on your selection on multibox, you have to make sure both objects has the same state.

you can check by right clicking and going to properties of the object and see under general tab. right after window title..

Alternate states drop down will appear only if you created at least one in document properties.

Re: Need help with conditional expression

Tue, 02 Sep 2014 23:56:30 GMT

They are both using the same alternate state.

Re: Need help with conditional expression

phaneendra_kunc — Tue, 02 Sep 2014 23:59:20 GMT

Hmmm... Not sure what is happening then...

It will be really helpful if you can share the sample QVW file with me..i will take a look into it...

Re: Need help with conditional expression

Wed, 03 Sep 2014 00:10:18 GMT

The qv file is extremely large, is there another option to have you look at it?

Re: Need help with conditional expression

phaneendra_kunc — Wed, 03 Sep 2014 00:18:42 GMT

you can always do a "Reduce Data" to skin down the app size.

select Data some filters that you want and which requires this computation and go to FILE --> Reduce Data--> Keep Possible values. And then you can Save As with a different file name.

if above is not possible just do a small test..

Create a new chart with SKU_MODEL, MTART as dimensions and count(Distinct MATNR) as expression

and share that image

Re: Need help with conditional expression

Wed, 03 Sep 2014 14:09:33 GMT

Attached is the image for the small test.

Re: Need help with conditional expression

phaneendra_kunc — Wed, 03 Sep 2014 14:47:16 GMT

Here is the explanation...your expression is already filtered to CIS and it is associated with only FERT and ZMOD in MTART field.

i bet you have 157178 distinct values for CIS. You can test that by removing MTART dimension from the above grid.

even though FERT has 157178 and ZMOD has 11 it doesn't mean that you will get 157189. You are doing distinct.

i Think you have some overlaps in your dataset for both.

if you want to see a change select ZMOD from MTART field.

Re: Need help with conditional expression

Wed, 03 Sep 2014 14:53:57 GMT

So is there a way to create separate pie charts for each SKU_MODEL by explicitly calling out each SKU_MODEL and use a single multi box to apply general filters to all of the pie charts? That is what I am trying to do rather than create separate pie charts and multi box for each one.

Re: Need help with conditional expression

phaneendra_kunc — Wed, 03 Sep 2014 15:19:09 GMT

I Would suggest a simple solution...

add your SKU Model as Dimension and count(Distinct MATNR) as expression in a pie chart.

ffor this chart if you enable Trellis then I will pop out single pie for each SKU Model. Enabling trellis is on properors window of the object and under general or chart..

Re: Need help with conditional expression

Wed, 03 Sep 2014 15:38:57 GMT

This is a great option however I don’t think it will satisfy my needs. What I am needing is separate pie charts for each SKU_MODEL. It seems that the trellis is breaking out the total pie chart into separate breakdown. I need each pie chart to be independently charted as a percentage of itself, not the whole.

Re: Need help with conditional expression

Wed, 03 Sep 2014 15:41:57 GMT

This is what I am trying to create without having to do independent multi box objects tied to each chart.

Re: Need help with conditional expression

Wed, 03 Sep 2014 16:51:33 GMT

Is there a way to accomplish this?