topic Dimension Filter based on selection? in QlikView

Dimension Filter based on selection?

rohitians — Fri, 30 Jan 2015 06:13:52 GMT

Hello Everyone,

The report is a simple sales report where industry sales is compared to individual sales of a company,

all companies have common SUPERGROUP but they may be present in different SUBGROUP,

but i want to display comparison of only those SUBGROUPS where in the individual company is present vs the industry for the same SUBGROUP,

kindly help.

In the below pic i just wanna show the subgroups highlighted in red and not all..

Re: Dimension Filter based on selection?

Fri, 30 Jan 2015 07:21:07 GMT

Hi Yadav,

i am not getting your requirement,Can you explain a bit more.

if possible post one sample QVW.

Thanks,

Chiru

Re: Dimension Filter based on selection?

Fri, 30 Jan 2015 07:44:54 GMT

use wildmatch function with if condition

if(wildmatch(SUBGROUP,'TOTAL'),SUBGROUP)

Re: Dimension Filter based on selection?

Fri, 30 Jan 2015 07:47:10 GMT

or you can limit your subgroup from Back End by your condition to the Subgroup which are present in the Individual Company using if or where condition.

For more clarification post your sample application