topic How to display the dimensions conditionally? in QlikView

How to display the dimensions conditionally?

pgrs4219 — Thu, 04 May 2017 20:08:22 GMT

Hi Community,

I have a requirement that i need to display the dimension of the chart conditionally by making the selections in the drop down list of pivot table.

So please help me with this. Here is the sample attachment please go through that.

Thanks

vishsaggi — Thu, 04 May 2017 20:34:25 GMT

Use like in Dimensions -> Enable Conditional check

= IF(GetSelectedCount(ArticleNo) > 0, 1, 0)

Check the attached. You want to display only when ArticleNo is selected or individual dimensions selected.

Just use the above if conditions for different dimensions in your source table.

= IF(GetSelectedCount(Batch) > 0, 1, 0) for Batch Dimension

= IF(GetSelectedCount(Week_No) > 0, 1, 0) for week dimension.

Anonymous — Thu, 04 May 2017 20:34:49 GMT

On the dimensions tab of your pivot table select 'Enable Conditional".

Enter formula like: =GetSelectedCount(ArticleNo)<>0

Replace 'ArticleNo' with the dimension name.

pgrs4219 — Thu, 04 May 2017 21:56:18 GMT

Hi Nagaraju,

Thanks you so much for your quick reply,

the above conditions are helped me, but i want to do the multiple dimension selections randomly, so can you suggest me for that also.

for example i want to select both ArticleNo and Batch at time i know i can use the below condition

IF(GetSelectedCount(ArticleNo) > 0, 1, 0)

or IF(GetSelectedCount(Batch) > 0, 1, 0)

But if i do that i can see the Artical no while selecting the batch also. so i need some dynamic approach. please help me with this also.

Thanks

vishsaggi — Thu, 04 May 2017 23:15:36 GMT

So when you have no selections in ArticleNo and a selection in the Batch what is that you want to see?