Hello,

I try to use alternate state to make it possible for end user to get insights which customer did order specific products (state_didBuy) and did not order specific other products (state_didntBuy).

For example: Show only customers who did order more than 2 drinks, but didn't order any burger this year. 

I only want to show customers in the table for whom criteria apply with sum(of state_didBuy)

Is this possible?

I did include sample qvf

The result with sample data should be only cust2 and cust3

Regards,

I surprised to find out that Max() cant be used in conditional statement of IF. I was trying to use ::

if(max(marks)=marks, Rollnumber)

type of statement. but its showing "error in expression".

Even set analysis isnt helping to get solution :

sum({$<marks={$(max(marks))}>} Rollnumber)

Hi,

I am using Valuelist to built a table 

I have 2 dimensions(State and Status) and a single measure using Valuelist as seen below

=If(ValueList('A', 'B','C')= 'A', COUNT({<[status] = {'A','B'},current_month = {'Current'}
>} DISTINCT Id),
If(ValueList('A', 'B','C')= 'B',COUNT({<[status] = {'B'},current_month = {'Current'},[Target Type] = {'B'}
>} DISTINCT Id),
If(ValueList('A', 'B','C')= 'C',COUNT({<[codes] = {">=1"}, [status] = {'B'}>} DISTINCT [Id]),
)))

This gives the following output 

Which is correct but I need to add another column sum by the state so that I get an output like 

I tried adding sum and total to the above measure but I am not getting the desired output 

I'm encountering an odd issue with NPrinting June 2019 and QlikView 12.4. I have an NPrinting report that connects to a QlikView app to generate an Excel recipient file, to be imported into the NPrinting user database. (My report's Excel template uses the sheet/column layout specified in Recipients.xlsx -- extracted from Examples.zip, which I downloaded from the NPrinting help page. The QlikView app has a hidden tab containing three tables -- Filters, Users, and Groups -- which expose the data referenced in the Excel template. I'm not using nor exposing the Filters sheet's Advanced Search.) When I run the publish task to run the report to generate the recipients file, the data on the Filters sheet is in the wrong columns; i.e., rather than this:

Name | Description | App | Enabled | Connection | Values | Numeric Values | Formulas | Advanced Search
<Name> | <Description> | <App> | <Enabled> | <Connection> | <Values> | <Numeric Values> | <Formulas>

The data looks like this:

Name | Description | App | Enabled | Connection | Values | Numeric Values | Formulas | Advanced Search
<Name> | <Values> | <Description> | <App> | <Enabled> | <Connection> | <Numeric Values> | <Formulas>

Note that the data in the second through sixth columns is mixed up. (The data on the Users and Groups columns is correct.) Not surprisingly, the data on the Filters sheet being in the wrong columns is causing the corresponding import task to fail!

I worked around the issue by changing the report's template to output each of the second through sixth columns in the 'wrong' location; i.e.,

Name | Description | App | Enabled | Connection | Values | Numeric Values | Formulas | Advanced Search
<Name> | <App> | <Enabled> | <Connection> | <Values> | <Description> | <Numeric Values> | <Formulas>

This results in a correct recipient file which can then be imported.

What steps have I taken to try to resolve this? I deleted and re-pasted the data columns in the Excel template. I deleted and re-imported the three table objects in the Excel template. I reloaded the connection's metadata. I deleted and re-created the report and template. I even deleted and re-created the connection and the app. I created a new report and template. No change. I'm not seeing this issue with any other NPrinting / QlikView apps.

What could be causing this issue?

Dear Experts,

I need to figure out how to do a rolling sum in the Qlik sense.

I have the data as shown below

Need the data  as below

Thanks for your time

Question.  I have on my dashboard a table chart with a few columns (Sales person, invoice#, sales total). 

When the user clicks on a row, how can I navigate to a different sheet and show all additional detail information based on the click? 

HI team

I Am trying to convert number to MIllion/Billions,

I have a Variable vScaleTotalARBal which return M or B or K

i am using pick match like vDivParam=Pick(alt(match($1,'B','M','K',''),0),1000000000,1000000,1000,1)

now if i use $(vDivParam(vScaleTotalARBal)) ir is returning null .

Thanks in Advance

@sunny_talwar 

So,
we've run in to a QV Plugin issue we can't figure out.
* Server/plugin: April 2019 SR1
* IE: 11.295.18362.0

On 2 new laptops with newer Win/IE version than before there is 1 thing that don't work with IE Plugin.
This is what vi do:
* Open any App
* Right click -> New Sheet Object
* Choose any of the alternatives, ex. list box
* Instead of a new window with properties popping up, everything just disappears.

See attached pic

Anyone with the same version of IE (or newer) that it works/don't works for?

(it works when running Ajax/Full browser version)