Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Lakshman_1031
Partner
Partner

Adhoc report with multiple dimensions

Hi All,

Is it possible to create Adhoc report with multiple dimensions.

 

Thanks & Regards,

Lakshman

 

2 Solutions

Accepted Solutions
Kush
MVP
MVP

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

View solution in original post

Kush
MVP
MVP

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

View solution in original post

12 Replies
zhadrakas
Specialist II
Specialist II

Lakshman_1031
Partner
Partner
Author

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
Creator
Creator

Are you able to post an example of your report?

While we teach we learn
Lakshman_1031
Partner
Partner
Author

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

Kush
MVP
MVP

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

Lakshman_1031
Partner
Partner
Author

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

 

Kush
MVP
MVP

Is it typo? your field name is Time. 

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

Lakshman_1031
Partner
Partner
Author

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

 

 

 

Kush
MVP
MVP

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

View solution in original post