Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I just started working on Qliksense migration and newbie to Qlik. I have below task to achieve
3 measure columns.
1. VT
2. CP
3. Vol
Ask is to bring above individual columns as filter and when user select one of the value from the filter, Visualization should show relevant values.
Above ask was done in tableau by using parameter. how to attain above ask in Qlik. Please help
create inline table :
Inl_Table:
load * inline [
DimName,DimID
VT,1
CP,2
Vol,3
];
in frontend use DimName as a filter
use below exression:
pick(match(DimName,VT,CP,Vol),sum(VT logic),sum(CP logic),sum(vol logic)
or create 3 measures then show conditional basis based on DimName selection
or else like below adhoc report
https://community.qlik.com/t5/Design/Customizable-Straight-Table/ba-p/1464825
Thanks Anat. it worked as expected.
You can create a variables
SET vVT = 'VT';
SET vCP = 'CP';
SET vVol = 'Vol';
And use like wise set analysis exp for all
Sum({<Measure={'$(vVT)'}>} YourDataField)
And add ur measure to filter pane..
Thanks for your reply.
In the filter drop down VT, CP and Vol should appear as text value upon selection of "VT", visualization should behave accordingly.
Currently when i add individual column to filter pane all values appears in the filter
VT | CP | Vol |
0.05155 | 0.222784 | 12.566668 |
1.24777 | 1.4001 | 58.565662 |
0.21145 | 2.221451 | 74.558 |
78.256 | 3.00125 | 88.3666 |
It's not really clear what do you want to do. Filtering field-values or aggregated results?
Filtering numeric field-values is very simple even if there are a lot distinct ones because the user could just apply appropriate searches on the field, for example typing something like: >=10<50. Helpful may also be to load these fields twice - ones with the origin values and the second time with a clustering like: class(MyField, 10) and then using it as filter-field.
If instead aggregated results should be filtered you will need to use a calculated dimension, like:
aggr(sum(MyField), Dim1, Dim2)
whereby Dim1 and Dim2 are just placeholder for the dimensional context in which the aggregation should be performed.
I think he is looking for ad-hoc table feature.
@jagdishbr , refer below thread
https://medium.com/@vader_94/custom-ad-hoc-reporting-in-qlik-sense-601c84d02993
Regards,
Prashant Sangle
Hi Jagdish,
Are you by chance trying to create an ADHOC report where your drop down will have 3 Measure Options : VT, CP & Volume. Then when the user selects one, the graph will use That selected value as measure ?
Regards,
Rohan.
create inline table :
Inl_Table:
load * inline [
DimName,DimID
VT,1
CP,2
Vol,3
];
in frontend use DimName as a filter
use below exression:
pick(match(DimName,VT,CP,Vol),sum(VT logic),sum(CP logic),sum(vol logic)
or create 3 measures then show conditional basis based on DimName selection
or else like below adhoc report
https://community.qlik.com/t5/Design/Customizable-Straight-Table/ba-p/1464825
Hi Marcus.
Thanks for replying.
I need VT, CP and Vol as items in the filter. When user make select as "VT" my visualization(bar/ chart) should SUM(VT)
I hope this is clear.
Yes Rohan. you are correct.