topic Re: adhoc reporting in QlikView

adhoc reporting

Shiva123 — Wed, 23 May 2018 01:00:08 GMT

hi,

all i am trying to figure a logic for adhoc reporting, where in i have two different sets of attributes and one set of measures, the issue is when the user wants to selects any one of the attributes the chart should be displayed excluding expressions. right now i have a logic saying select all three of them, is there any logic to pick one attribute. any help would be great. i have done the basic requirements for adhoc reporting.

my expression is like this

GetSelectedCount (dimension set 1)>0 and GetSelectedCount (dimension set 2)>0 and GetSelectedCount (expressions )>0

thanks

Shiva

Re: adhoc reporting

sunny_talwar — Wed, 23 May 2018 01:56:34 GMT

May be you want this

(GetSelectedCount(dimension set 1) > 0 or GetSelectedCount(dimension set 2) > 0) and GetSelectedCount(expressions) > 0

Re: adhoc reporting

Shiva123 — Wed, 23 May 2018 16:36:26 GMT

this condition doesn't work @sunny , if i pick one dimension from dimension set1 and one measure, it is displaying all the dimensions in dimension set 2

condition for dimesions

SubStringCount(Concat(Attribute, '|'), '$(=only({$ <AttributeNO={1}>} Attribute))')

conditions for expression

SubStringCount(Concat(Measures, '|'), '$(=only({$ <MeasureNO={1}>} Measures))')

thanks again

Re: adhoc reporting

sunny_talwar — Wed, 23 May 2018 16:40:33 GMT

It might make is easy if you can share a sample of what you have....

Re: adhoc reporting

Shiva123 — Wed, 23 May 2018 17:06:58 GMT

attached is the app

Re: adhoc reporting

sunny_talwar — Wed, 23 May 2018 17:37:18 GMT

Yes

Re: adhoc reporting

Shiva123 — Wed, 23 May 2018 18:16:27 GMT

i have attached the app

Re: adhoc reporting

sunny_talwar — Wed, 23 May 2018 18:24:23 GMT

Check the attached with the changes implemented

Re: adhoc reporting

Shiva123 — Wed, 23 May 2018 18:38:34 GMT

thank you so much , again you are amazing man .....