Measure as Filter

[jagdishbr]

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

[Chanty4u]

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

[Rohan]

@PrashantSangle Look at this, they seem to be migrating from Tableau to Qlik sense.

Regards,

Rohan.

[jagdishbr]

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

[marcus_sommer]

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.

[PrashantSangle]

I think he is looking for ad-hoc table feature. 

@jagdishbr , refer below thread

https://community.qlik.com/t5/Design/Is-there-really-one-type-of-Ad-hoc-Reporting-with-Qlik-Sense/ba....

https://medium.com/@vader_94/custom-ad-hoc-reporting-in-qlik-sense-601c84d02993

Regards,

Prashant Sangle

[Rohan]

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.

[anat · Accepted solution]

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

[jagdishbr]

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.

[jagdishbr]

Yes Rohan.  you are correct.