Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to create Adhoc report with multiple dimensions.
Thanks & Regards,
Lakshman
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
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
check this thread for a working example:
https://community.qlik.com/t5/QlikView-Documents/Adhoc-reporting-in-Qlikview/ta-p/1478373
regards
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
Are you able to post an example of your report?
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
Not completely understand what do you want to achieve. Can you please put one example?
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
Is it typo? your field name is Time.
(GetSelectedCount(Supply)>0 or GetSelectedCount(Time)>0) and GetSelectedCount(Measure)>0
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
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