Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to create drill down month to day , day to name of the bioreactor for getting information for power consumption.
but it is working file month to day but not working in day to bioreacto.
please let me where is my mistake.
please help me
Hello abcd1234,
you are using a drill down group. This works fine when the members of your group are in a hierarchical enviroment. As month(MyDate) and Day(MyDate) --> works fine for a drill down group. But your ID and Name fields do not fit into this structure. Therefor try to use the three in a cyclic group.
Additional Notes: The syntax of
isn't correct. Replace || with &. This is qlikview, not SQL 😉=AQUIFAS_NAME||AQUIFAS_ID
Regards,
Roland
thanks for your input.please let me know in my case how will i resolve ?
n.b-cyclic redundancy is not given me the result which i want.
power consumption by month->power consumption by day->power consumption by reactor
Hi abcd1234,
See attached and confirm that it fits your need.
Regards
hello again,
take a look at my chart "RK" to see a cyclic group and the correct syntax for the mentioned expre. above
RR
perfect.thanks
it is also perfect.