topic Re: Ad-hoc report expression in QlikView

Ad-hoc report expression

vijetas42 — Wed, 15 Jul 2015 12:43:45 GMT

Hi all,

Currently i am having one issue with my Ad-hoc report, I am having 2 metrics like,Impressions and Impressions_P25_54 when i write condition on both the metric at that time if I select single value then it works fine for Impressions but when i select Impressions_P25_54 then it will display Impressions too. and if i select both the metrics then it displays only Impressions_P25_54 not Impressions .In this case how to write expression.

Thanks

Re: Ad-hoc report expression

robert_mika — Wed, 15 Jul 2015 12:48:21 GMT

Could you attached your app or screenshot?

Re: Ad-hoc report expression

ankit777 — Wed, 15 Jul 2015 12:51:34 GMT

Hi,

What conditions are you using?

Re: Ad-hoc report expression

vijetas42 — Wed, 15 Jul 2015 12:52:43 GMT

Hi,

due to company policies i could not attach screenshot.but i can tell what are the expression i am using,

SubStringCount(Concat([TV]),'|'),'Impressions')=1 and GetSelectedCount(TV)>0 and same for

SubStringCount(Concat([TV]),'|'),'Impressions_P25_54')=1 and GetSelectedCount(TV)>0

Re: Ad-hoc report expression

ankit777 — Wed, 15 Jul 2015 15:31:06 GMT

Hi,

considering [TV] field has two values only='Impressions' and 'Impressions_P25_54'

Use following conditions:

1. [TV]='Impressions' or getselectedcount(TV)=2

2. [TV]= 'Impressions_P25_54' or getselectedcount(TV)=2

Re: Ad-hoc report expression

settu_periasamy — Wed, 15 Jul 2015 16:07:57 GMT

Try this

SubStringCount(Concat(Distinct [TV]),'|'),'Impressions') and GetSelectedCount(TV)>0

SubStringCount(Concat(Distinct [TV]),'|'),'Impressions_P25_54') and GetSelectedCount(TV)>0

Below link would be helpful.

Customizable Straight Table