Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
I wanna show the diff b/w two values dynamically. I've 4 expression and one more expression for Difference using in Ad-hoc concept.
when I select any two exp from that 4 it show the Diff b/w that 2 exp in the same table. based on current selection only it should show
For Example
if I've Exp like below,
%Expression
Total Sales-14, //(Sum TSales-14)
Total Sales-15, //(Sum TSales-15)
Sales-14, //(Sum Sales-14)
Sales-15, //(Sum Sales-15)
Diff //(???????????????)
for Diff I don't know what kind of exp I 've to try..
User can select any 2 dimension to know the Diff. So I need that exp as Dynamically (Based on User current Selected Expressions)
Thanks
in advance
Abinesh S
If your 2 expressions are dynamically selected, you could write your difference like that:
= Column(2) - Column(1)
Try like this?
=(Sum TSales-14) - (Sum TSales-15) as per your requirement
Thanks for you reply Balraj,
I need that exp dynamically.... In your exp it show only Diff b/w 14 &15 Total sales only but In user point of view they will select any exp like "TSale-14 - Sale-15" or "Sale-14 -TSale-15" So I need that Diff exp completely based on user selection only...
like this?
Hi,
Adhoc Reporting will help you to achieve above concept.
You need to customize that concept according to your requirement.
For how to create Adhoc report navigate below link
Regards,
If your 2 expressions are dynamically selected, you could write your difference like that:
= Column(2) - Column(1)
Thanks Sebastien its work properly.. Thank you very much. And one more doubt when I select the exp in adhoc it sort the exp by values but I wanna sort the exp by user selection wise.
For eg:
Sales=1000
Target=1100
User select the Target 1st and the select sales 2nd and check the diff in that time in qlik view it show "-100" based on values it sorting itself.... guys help on this also
Guys thanks to all of you I got the solution for my 2nd query also...
New question --> new thread
It will more helpfull for other users.
You could refer to this thread and add a sample of your application, it will be more simple to understand what you did and how to help you.
The expressions are taken in the list box and take the text box write the expression getselectioncount(field)- ( getselectioncount(field)-1)