Adhoc report with multiple dimensions

[Lakshman_1031]

Hi All,

Is it possible to create Adhoc report with multiple dimensions.

Thanks & Regards,

Lakshman

[zhadrakas]

check this thread for a working example:

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

regards

[Lakshman_1031]

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

[Victor_Alumanah]

Are you able to post an example of your report?

[Lakshman_1031]

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

[Kushal_Chawda]

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

[Lakshman_1031]

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

[Kushal_Chawda]

Is it typo? your field name is Time. 

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

[Lakshman_1031]

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

[Kushal_Chawda · Accepted solution]

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