topic Re: Adhoc report with multiple dimensions in QlikView

Adhoc report with multiple dimensions

Lakshman_1031 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Is it possible to create Adhoc report with multiple dimensions.

Thanks & Regards,

Lakshman

Re: Adhoc report with multiple dimensions

zhadrakas — Fri, 03 Jan 2020 10:49:49 GMT

check this thread for a working example:

https://community.qlik.com/t5/QlikView-Documents/Adhoc-reporting-in-Qlikview/ta-p/1478373

regards

Re: Adhoc report with multiple dimensions

Lakshman_1031 — Fri, 03 Jan 2020 11:42:08 GMT

Hi ,

Thanks for replay,

I have checked link, but here using single dimension only.

but i have 3 dimensions and one measure.

if using one dimension and one measure then use getselectedcount(Dimension)>0 and getselectedcount(Measure)

but if i take 3 dimensions how to write the code.

I have used

getselectedcount(Dimension 1)>0 or getselectedcount(Dimension 2)>0 and getselectedcount(Measure) .

Please suggest me how to achieve this scenario.

is there any possibility can you share example.

Thanks & Regards,

Lakshman

Re: Adhoc report with multiple dimensions

Victor_Alumanah — Fri, 03 Jan 2020 14:59:08 GMT

Are you able to post an example of your report?

Re: Adhoc report with multiple dimensions

Lakshman_1031 — Fri, 03 Jan 2020 16:19:22 GMT

Hi ,

Please see the below attached sample Qvw for your reference.

my requirement is i have 2 dimension and 1 measure.

if i select Dimension 1 and measure then automatically display the dimension 2 also.

if i select dimension 2 then only display the data.

Please suggest me how to achieve this scenario.

Regards,

Lakshman

Re: Adhoc report with multiple dimensions

Kushal_Chawda — Fri, 03 Jan 2020 16:36:34 GMT

Not completely understand what do you want to achieve. Can you please put one example?

Re: Adhoc report with multiple dimensions

Lakshman_1031 — Sat, 04 Jan 2020 09:08:56 GMT

Hi ,

Actually we will use One dimension and One Measure to create the Adhoc report.

But my problem is to create the adhoc report with multiple dimensions.

I have table like

Load Supply 1,

Supply 2 ,

Supply 3,

Month,

Quarter ,

Year,

Sales

from table.

Supply:

Load * inline [

Supply

Supply 1,

Supply 2,

Supply 3

];

[Time period]:

Load * inline [

Time

Year,

Quarter,

Month

];

Measures:

Load * inline [

Measure

Sum,

Avg,

Max

];

i have create pivot table and i have taken Supply and Time period as Dimensions and Measure as Measure.

In general tab i have write getselectedcount(Supply)>0 and getselectedcount(Measure)>0

i have taken one dimension and One measure it is working fine.

i have taken two dimensions with one measure is not working properly.

GetSelectedCount(Supply)>0 or GetSelectedCount(Time period) and GetSelectedCount(Measure)>0

Please suggest me is it possible to achieve this one. if possible please suggest me how to achieve this scenario.

Regards,

lakshman

Re: Adhoc report with multiple dimensions

Kushal_Chawda — Sat, 04 Jan 2020 12:04:03 GMT

Is it typo? your field name is Time.

(GetSelectedCount(Supply)>0 or GetSelectedCount(Time)>0) and GetSelectedCount(Measure)>0

Re: Adhoc report with multiple dimensions

Lakshman_1031 — Sat, 04 Jan 2020 15:28:44 GMT

Hi ,

Thanks for your replay.

Time period is Field Name.

I have wrote same code but if i select Supply 1 and supply 2 in Supply filed and Select measure it is showing 2nd dimension values also.

my requirement is if i select the second dimension then only 2nd dimension values visible otherwise display Dimension 1 selected values and corresponding Measure values.

i have used

(GetSelectedCount(Supply)>0 and GetSelectedCount(Time)>0) and GetSelectedCount(Measure)>0

i have selected Supply, Time and Measure at least one selection then only chart will display.

if i use this code

(GetSelectedCount(Supply)>0 or GetSelectedCount(Time)>0) and GetSelectedCount(Measure)>0

if i am not selected time it is also coming.

Please suggest me is there any way to achieve this scenario.

Regards,

Lakshman

Re: Adhoc report with multiple dimensions

Kushal_Chawda — Sun, 05 Jan 2020 13:15:40 GMT

In chart Calculated condition(In General tab) put below expression

=(GetSelectedCount(Supply)>0 or GetSelectedCount(Time)>0) and GetSelectedCount(Measure)>0

For Supply Dimensions in Chart, check 'Enable Condition' and put below expression for each dimension

=if(wildmatch(concat(GetFieldSelections(Supply),','),'*Supply 1*'),1,0) - For Supply 1 Dimension

For Time Dimensions in Chart, check 'Enable Condition' and put below expression for each dimension

=if(wildmatch(concat(GetFieldSelections(Time),','),'*Year*'),1,0)

For Measure Dimensions in Chart, check 'Enable Condition' and put below expression for each dimension

=if(wildmatch(concat(GetFieldSelections(Measure),','),'*Avg*'),1,0)

Note: Apply conditional for each dimension using above expressions

Re: Adhoc report with multiple dimensions

Lakshman_1031 — Mon, 06 Jan 2020 10:28:57 GMT

Hi ,

Thanks very much for your support.

Finally I achieved.

Regards,

lakshman

Re: Adhoc report with multiple dimensions

Kushal_Chawda — Mon, 06 Jan 2020 11:38:17 GMT

Please mark the answer as correct if any suggestion helped else post the solution and mark it as correct so that others can refer it for same problem

Re: Adhoc report with multiple dimensions

Brett_Bleess — Mon, 06 Jan 2020 14:04:45 GMT

Laksman, I just wanted to remind you to be sure to use the Accept as Solution button on Kush's post(s) that helped if that is what got you going. If you did something different, please consider posting the details on that and then after you post that, use the Accept as Solution button on it to mark it. It is important to do this as it gives the posters credit for the help and it also lets the other Community Members know what actually worked... Shout if you have further questions, thanks in advance for the follow-up. I would have marked things, but it was not clear to me if you used Kush's info or you figured out something on your own. If Kush did help, but you had to do something further, you can mark two things too, you could mark Kush's post and then do your own with the extra details and mark that too...

Cheers,
Brett