How can use Drill Down GROUP in expression of Qlik sense.

[sspawar88]

HI community,

i have created one Drilled Down group in Qlikview as well in Qlik sense which name is GR

GR is drilled down group of branch_name, branch_type ,loc_code and loc_type.

Following Expression is working in Qlikview but not in Qlik sense.

Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)

/Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),$(=GetCurrentField(GR)))

How we can use drilled down group name is Qlik sense expression?

is it any way like Qlikview?

[deepakqlikview_123]

use drill down  group name in dimension.

thanks

[sspawar88]

its not working.

i used group name in Dimension.

but it won't give result as Qlikview.

[alex_nerush]

GetCurrentField function is not supported in Qlik Sense.

See http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/QlikView-functions-...

[ogster1974]

I've tried it myself before. Qlik Sense doesn't currently support use of master items in expressions.  This goes for the Measures created as well as Dimensions.  hopefully they will allow it in a future release as will neaten up my expressions greatly.

Id also like cylindrical drill downs to on my wish list not just drill downs.

Regards

Andy

[sspawar88]

is any way to make it workout?

mto‌

[sspawar88]

is any way to make it workout?

[ogster1974]

As a different approach you may want to consider.  I've been playing with  an Extension to add a variable capability into Qlik Sense.  Go to Qlik Branch and download it its called qsVariable and add it as an extension.

Perhaps on your page above the chart you want to manipulate add this variable called vCR make it a button with 4 values branch_name, branch_type ,loc_code and loc_type.  Note you can have it as a drop down, free text or slider control.

SET a Default value for this variable on Load.

Then in your chart use If(vGR='branch_name',Expr1(If(vGR='branch_type',Expr2....

Do this for your Dimension and Measures.  You lose drill down capability but you get different views in the same chart space.

I used it to switch my calendar views on charts from transactional dates to reporting ones using this technique.

Hope this helps

Regards

Andy

[alex_nerush]

The workaround solution could be use of COUNT function to determine selections in drill group fields, and thus to decide wich field from the drill group is currently active.

p.s. the same problem was discussed here: QLIK SENSE: $(=GetCurrentField(Time))

[sspawar88]

Can you explore it..how can i use count to overcome the use of GetCurrentField()   ?